package edu.must.uh.impl;

import java.util.List;
import java.util.Map;
import edu.must.uh.util.SqlUtils;
import edu.must.uh.util.Tools;
import edu.must.uh.util.ToolsOfString;

public class CardNumImpl extends BaseImpl {

    public CardNumImpl() {
         super.cashkey     = "cardnum";
         super.cashListkey = "cardnum";
         super.keyFields   = "ID";
         super.tableName   = "cardnum"; 
    }
    
    public  List<Map<String,Object>> getList(Map<String, Object> searchcondition,
            String sqlcondition) throws Exception {        
           
            String sqlString = "SELECT cardnum.ID, cardnum.UserId, cardnum.CARDNUM, cardnum.DELETEMARK, cardnum.SORTCODE, cardnum.CREATEUSER cardnum.CREATETIME " + 
                    "FROM cardnum where DELETEMARK = 0 ";
                   
            sqlString = sqlString + Tools.getSQLCondition(searchcondition);
            sqlString = sqlString +ToolsOfString.NulltoEmpty(sqlcondition) ;  
            List<Map<String,Object>>resList = SqlUtils.getMySqlInstance().getlist(sqlString);
            return resList;
        }
    
}
